package com.nbjtjc.safe.mapper.emg;

import com.nbjtjc.safe.model.emg.EmgPlanGoods;
import com.nbjtjc.util.MyMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface EmgPlanGoodsMapper extends MyMapper<EmgPlanGoods> {

    @Select("select * from emg_plan_goods where plan_id=#{planId}")
    List<EmgPlanGoods> findByPlanId(@Param("planId") int planId);
    @Delete("delete from emg_plan_goods where plan_id=#{planId} ")
    int deleteByPlanId(@Param("planId") int planId);
}